<?php

use Illuminate\Database\Schema\Blueprint;

class CreateCaVisits extends \App\Utils\CreateMigration
{
    function columns(Blueprint $table)
    {
        $table->unsignedBigInteger('hospital_id')->default(0)->comment('医院编号');
        $table->unsignedBigInteger('customer_id')->default(0)->comment('客户ID');
        $table->unsignedBigInteger('user_id')->default(0)->comment('用户编号');
        $table->string('content')->nullable()->comment('回访内容');
        $table->string('next_time')->nullable()->comment('下次回访时间');
        $table->string('supervisor_annotate')->nullable()->comment('主管批注');
        $table->index(['customer_id'], 'idx_customer_id');
    }

    function tableInfo()
    {
        return ['ca__visits', '咨询预约-回访'];
    }
}
